﻿CREATE TABLE [dbo].[AngajatiSume] (
    [IDPontajSuma]        INT             IDENTITY (1, 1) NOT NULL,
    [IDPersoana]          INT             NOT NULL,
    [IDAngajatSalarizare] INT             NOT NULL,
    [Suma]                DECIMAL (18, 2) CONSTRAINT [DF_AngajatiPontajSume_Suma] DEFAULT ((0)) NOT NULL,
    [TotalOreLucrate]     DECIMAL (18, 2) CONSTRAINT [DF_AngajatiPontajSume_TotalOreLucrate] DEFAULT ((0)) NOT NULL,
    [TipSuma]             VARCHAR (5)     CONSTRAINT [DF_AngajatiPontajSume_TipSuma] DEFAULT ('X') NOT NULL,
    [Anul]                SMALLINT        CONSTRAINT [DF_AngajatiPontajSume_Anul] DEFAULT ((2000)) NOT NULL,
    [Luna]                SMALLINT        CONSTRAINT [DF_AngajatiPontajSume_Luna] DEFAULT ((1)) NOT NULL,
    CONSTRAINT [PK_AngajatiPontajSume] PRIMARY KEY CLUSTERED ([IDPontajSuma] ASC)
);

